TRAVERSE Global v11.1
Components Pegging View
Use the Components Pegging View function to view where the demand for components originates, pegging the component to the main assembly.
Note: This view shows you all of the sales orders, sales forecasts, production orders, purchase orders, and purchase requisitions that affect the availability of the selected item.
The Component Pegging View is similar to the Item Activity View except that it uses a Period Definition ID to try to emulate the way a Standard RP Report would actually calculate availability on a period by period basis. All transactions are shown but the Applicable check box allows you to see which transactions are actually applicable and which ones are not.
It's important to select the same Period Definition ID as was used on the Standard RP Report and the same starting date to get accurate results. A day earlier or a day later could affect the output of the report or view.
- Select the item for which to view component pegging information from the Item ID field.
Note: The Location ID and Unit fields display the default information from Inventory. Adjust these fields if necessary. - Select the time period for which you want to view information from the Period Definition ID field.
- Click the Apply button, in the toolbar, to generate the demand for the selected item.
When viewing the Components Pegging View, you can arrange the columns in any desired order to better streamline them for your viewing purposes. To arrange columns, click on the heading of the column to move and drag the heading to the desired location among the other headings.
When you define IDs and codes, it is important for you to know how they appear in a field list after they are sorted. TRAVERSE sorts alphanumeric data alphabetically by comparing first characters, then second characters, and so forth. When two alphanumeric characters are compared, the character with the smaller ASCII value comes first in the alphabetic sort.
The list of alphanumeric characters is in ascending alphabetic order:
- Special characters (-, *, /, and so forth)
- Numbers (0-9)
- Uppercase letters (A-Z)
- Lowercase letters (a-z)
Alphabetical rules are not intuitive when numbers are involved. For example, in numerical sorting 60 comes before 112; however, in alphabetical sorting 112 comes before 60. To ensure that numbers appear in the same order in both an alphabetic and numeric sort, pad numbers to the left with zeros until they are the same length. For example, if 60 is defined as 060, 060 comes before 112 in both an alphabetic and a numeric sort.
Sort | By |
Ascending | Clicking the column heading until the appears |
Descending | Clicking the column heading until the appears |
You can sort columns to group and filter the data. To sort and filter the columns, right-click a column and use the functions outlined in the table below.
Button | Name | Select To |
Sort Ascending | Sort the selected column's data in ascending order. Note: You can also accomplish this task by clicking the column heading until the appears. |
|
Sort Descending | Sort the selected column's data in descending order. Note: You can also accomplish this task by clicking the column heading until the appears. |
|
Clear Sorting | Remove all sorting options and revert to the default view. | |
Group By This Column | Group the identical entries from this column into a single group. Note: If you group by column entry, you can right-click on the grouped column heading to select from the options outlined in this table as well as Full Expand (expand all of the grouped entries), Full Collapse (collapse all of the grouped entries), or UnGroup (undo the grouped entry). |
|
Column Chooser | Open the Customization window. Proceed to click and drag columns from this window to place them back into the table. Note: You can also accomplish this task by clicking on the heading of the column to remove and drag the heading to the bottom of the screen and release once your cursor changes to a large 'X'. |
|
Best Fit | Adjust the selected column to best view that column's data. | |
Clear Filter | Remove all filter options and revert to the default view. | |
Filter Editor | See the Filtering Across All Columns section for more information. | |
Best Fit (all columns) | Adjust all columns to best view all of the data at once. |
- Click the funnel icon that appears once you place the cursor in the desired column to filter.
- Select a filter option from the drop down menu.
Note: From this drop-down list, you can also select from the entries in the selected column to group the column by the selected entry.
Select | To |
(Custom) | Enter criteria for filtering the selected column. Note: View the following paragraph for additional information. |
(Blanks) | Display only entries with blank information in the selected column. |
(Non blanks) | Display only entries with information in the selected column. |
Note: If you select (Custom), the Custom AutoFilter function appears. Select up to two filtering criteria for the selected column from the drop-down menus, then enter a string of text or numbers to complete the condition before clicking OK. |
To create a filter across all columns, use the Filter Editor function to create a filtering condition. A filter condition can consist of up to four options. Each option within the condition appears as a different color to help distinguish it from the other options, Red Text [Blue Text] Green Text <gray text>. The instructions below illustrate how to build a condition.
- Select how to group values by clicking the red text component (See Table 1).
- Select a column heading to filter by clicking the blue text component.
- Select the filtering criterion by clicking the green text component (See Table 2).
- Enter, if applicable, a string of text or numbers to complete the condition by clicking the gray text component.
- Click Apply.
- Click OK.
Button | Name |
And | |
Or | |
Not And | |
Not Or | |
Add Condition | |
Add Group | |
Clear All | |
Table 1 - Red Component | |
Button | Name |
Equals | |
Does not equal | |
Is greater than | |
Is greater than or equal to | |
Is less than | |
Is less than or equal to | |
Is between | |
Is not between | |
Contains | |
Does not contain | |
Begins with | |
Ends with | |
Is like | |
Is not like | |
Is blank | |
Is not blank | |
Is any of | |
Is none of | |
Table 2 - Green Component |
After arranging and sorting the columns how you want to view the information:
Use the Preview Report button to view a preview of the information as a report. To print the report, click the Print button or to export the report to a PDF, HTML, MHT, RTF, Excel, CSV, Text, or Image File, click the Export Document button.
Use the Export Data button to export and save the data as an HTML, XML, plain text, or Microsoft Excel document.
Note: Depending on the output type selected, the information may export exactly as it appears on the screen, including column widths and expanded or collapsed grouped entries.
Use the Views button to save the current parameters set for the interactive view for using at a later time. You can also use the button to select, edit, or delete from the multiple saved views.
Use the Reset Layout button to reset the column headings and any sorting changes made to the information table.
For more information on using interactive views, see the Interactive Views Overview and Using Reports.